UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zz4f5mYN6LhBQZY0cj4/Hci1B67aCaYzg67v6kq6t6E='
WHERE
key_id = 'd1f40dcef09bb41dd39c613c4c4a7a122d94e779a8a57fb10ad00f6380c2279a'
AND (
token = 'Zz4f5mYN6LhBQZY0cj4/Hci1B67aCaYzg67v6kq6t6E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)