UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hocslIUSNk4cFEAK/kMcMiLX6b7FZJA1bZNGmIx7rv4='
WHERE
key_id = '58d9c4dbb87807fcbaecb85794a1a9c57093630616bded14723572175cc8bdf6'
AND (
token = 'hocslIUSNk4cFEAK/kMcMiLX6b7FZJA1bZNGmIx7rv4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)