UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rGMa/hpUprTPFw5XCCDS1ztiVaWicmW/hVjPSzIyoIU='
WHERE
key_id = 'ca7483025a857bc03ab17cc03c9fa4a20953a8462a5c023eb4bead763a2991fd'
AND (
token = 'rGMa/hpUprTPFw5XCCDS1ztiVaWicmW/hVjPSzIyoIU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)