UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4IqbM1dpHPWvidCmJJCQENxM4YpIChqxiUkuYRd23xw='
WHERE
key_id = 'b4a161566d0da9b1418999c0d3bafff4d5975572086f94a8b1dd7bf4447b8f55'
AND (
token = '4IqbM1dpHPWvidCmJJCQENxM4YpIChqxiUkuYRd23xw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)