UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YCo/5XGgTbjxUnz5OF7FwZ95wR9o7BUHjofsJHWCuH0='
WHERE
key_id = 'f653701a0b251f8ba1dc718a8aeec7a3ae21402ab3c12e0fd0045b5bfaf7e6aa'
AND (
token = 'YCo/5XGgTbjxUnz5OF7FwZ95wR9o7BUHjofsJHWCuH0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)