UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N0ywd/xAhtv8ifDF+e5prPCgHMc4Oi08lvD3smIbgVU='
WHERE
key_id = '936be8c9af38bf6328954610441ae7958f478bd259600a23363afa8cc979d007'
AND (
token = 'N0ywd/xAhtv8ifDF+e5prPCgHMc4Oi08lvD3smIbgVU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)