UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a6CIu2FPFNkZpLSYJa0HaAOtg63vEwlJVIR3HV+rzoU='
WHERE
key_id = '8c98173ea49aa75eecff41b0ad0441e1e321c220ba1a1941184725f5c7165895'
AND (
token = 'a6CIu2FPFNkZpLSYJa0HaAOtg63vEwlJVIR3HV+rzoU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)