UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BjYixXxL0VeeEET/IQFOOCrRZvmyIa8RtN3gKfoNHPw='
WHERE
key_id = '7fe0647d4f4f6aa5e0efee7ed7773a762f6c361a24a54ef5e99dc5e99085775a'
AND (
token = 'BjYixXxL0VeeEET/IQFOOCrRZvmyIa8RtN3gKfoNHPw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)