UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DXThnVeVlk8zgQjObZCmxPzuQtbzVn5aBsarzFuN8Qw='
WHERE
key_id = 'c629dccaddb7746d10ccaebf04cdc41684c26a04b36a765a2084dc66d7b3377a'
AND (
token = 'DXThnVeVlk8zgQjObZCmxPzuQtbzVn5aBsarzFuN8Qw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)