UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BLK/3xvqoKgF0R7UMbpr5sucV3zcW7eGSGFNBOEG45A='
WHERE
key_id = 'fcfabee83edfd0b1697a4aeee44725bddd05c6fc97301945f2ef9d51dd19ec23'
AND (
token = 'BLK/3xvqoKgF0R7UMbpr5sucV3zcW7eGSGFNBOEG45A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)