UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vzpugiAjNimN93RhMGtN8DYZRI1bKVkaElsk4d17mt8='
WHERE
key_id = '8b3e9125f053119b73a7f93565066bbbfbf09d5916418118112970b79d48a0b3'
AND (
token = 'vzpugiAjNimN93RhMGtN8DYZRI1bKVkaElsk4d17mt8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)