UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XiE/CpH5HiRlfNhAmNHHrI4vTD+US08rUazmMXj/jB0='
WHERE
key_id = '330e2c55d596a6e4430a42b60313c3876efe43322fa57959a094f4162dde4d18'
AND (
token = 'XiE/CpH5HiRlfNhAmNHHrI4vTD+US08rUazmMXj/jB0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)