UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Sj4vHuuDavT6carRsuamEyg0ht9vNH7y2LJ7tyoCh+U='
WHERE
key_id = 'a81164c264cd503933126a2aacb3ff028e4d0e16d7d05b6e80bde6d3fe056f70'
AND (
token = 'Sj4vHuuDavT6carRsuamEyg0ht9vNH7y2LJ7tyoCh+U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)