UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oLy2VsLyc6vOW4op8JlggjEeYvUgp+EdIun/krsjyE8='
WHERE
key_id = '3f566ab3cbc1ade51e99fbddba5af11ca574534f25e893255ae2a6a89e426fcc'
AND (
token = 'oLy2VsLyc6vOW4op8JlggjEeYvUgp+EdIun/krsjyE8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)