UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QRdjIwaqbcFQBMBAo5zI0YcrF5JbDws2yFZpPJQoRbo='
WHERE
key_id = '84bc29d7be1cc4aac7f70f32f272f42a4712537ce3601c06bfa05c97b89d8fd6'
AND (
token = 'QRdjIwaqbcFQBMBAo5zI0YcrF5JbDws2yFZpPJQoRbo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)