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