UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fzWa20LEIG4VAssr0qzX5npKKeFtDZ+pndd5HzCTxX4='
WHERE
key_id = 'b54aa2c3695d0e81ea55e49380b2891db0a4215b36354bbe665c1b0ba21e3f49'
AND (
token = 'fzWa20LEIG4VAssr0qzX5npKKeFtDZ+pndd5HzCTxX4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)