UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zPQMrNFIvxgmkK/uvycKqDze7SaNe5AnQxuHrd5+drA='
WHERE
key_id = 'bc49353b14b932beb4a78aa23c68f0f9669db167ac4d53573c518fb9bdfe3765'
AND (
token = 'zPQMrNFIvxgmkK/uvycKqDze7SaNe5AnQxuHrd5+drA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)