UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'm+lUmZCy5wmigZNhkzTg3V1rm7xLnz5UC572CVHusHw='
WHERE
key_id = '7d4820c9e36b116ab70dbffa933f0ae4ec12c3db8c50e54719625c1978064dee'
AND (
token = 'm+lUmZCy5wmigZNhkzTg3V1rm7xLnz5UC572CVHusHw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)