UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4tWabcKFHV3Waa0wun80AGQV32jvy5mLC0FIuo/j140='
WHERE
key_id = '6377c96fa2f61c852a5ad44205a61a5affeaeeb0eb0a8aa818d80d197e8ac31f'
AND (
token = '4tWabcKFHV3Waa0wun80AGQV32jvy5mLC0FIuo/j140='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)