UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UsQ4chnfAHfl9aQM59Rhx+y/02UeE7GI1pSdJGUuGuA='
WHERE
key_id = 'ad9eeabef108af3628077ffcb4753105630e98e31428703f61c6d865193d13a7'
AND (
token = 'UsQ4chnfAHfl9aQM59Rhx+y/02UeE7GI1pSdJGUuGuA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)