UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MdFqjvxV5yOLxfXX0uSya6cRNKYbcW/HZVgM6D9DELw='
WHERE
key_id = 'ec3c990946881bf1b97bd8c44ce3393cefa33eded8bcf4cd903888b17d50d121'
AND (
token = 'MdFqjvxV5yOLxfXX0uSya6cRNKYbcW/HZVgM6D9DELw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)