UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZoB40OFC233OiPRsIme0LE1Ufs2OOWe2Zl5jnikjmys='
WHERE
key_id = '7e6caf446a1bca88afc95300683541fe741ad7a1d3d12d33620c2882eab30c1f'
AND (
token = 'ZoB40OFC233OiPRsIme0LE1Ufs2OOWe2Zl5jnikjmys='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)