UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RDtNVP4uFxe98tjCaVIK3LXR2/l/8khfYmz1EFieNc8='
WHERE
key_id = 'c93c28c88292e454ecf7fa8b345a9afc1cf3a9d0edfa29570d25c96936d90ce6'
AND (
token = 'RDtNVP4uFxe98tjCaVIK3LXR2/l/8khfYmz1EFieNc8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)