UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ht02RUCrg1gCYdT2sBXVE8otOGeoffR5hGXXeYQ4qm8='
WHERE
key_id = '994404f79d1c5e645983e486b8b3e97371325a1e33ab27b1d1eb10bf5ce71ae7'
AND (
token = 'Ht02RUCrg1gCYdT2sBXVE8otOGeoffR5hGXXeYQ4qm8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)