UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XdzgnUyel2R84iB1KUKmSvtd0jywboFnGWpuBto8J8k='
WHERE
key_id = 'aa1987223182dfe002a4a82575d94d9c61c4afbc1ba5a25f326155585ba6c2a6'
AND (
token = 'XdzgnUyel2R84iB1KUKmSvtd0jywboFnGWpuBto8J8k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)