UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pVwq5A8gqW+9lyzbuUuaWaA6zwe992cdebrhb/Ds+eU='
WHERE
key_id = 'a05c5ce43c0fac350b9c681abb1629a4193f5209d61341e17cf32524969402aa'
AND (
token = 'pVwq5A8gqW+9lyzbuUuaWaA6zwe992cdebrhb/Ds+eU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)