UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XWugCpH/rwmUlaNgAo0CpuwKSPSACT31jEiHfbrfwRQ='
WHERE
key_id = '74171f005bc2ddf764d954bd49612a0c19fef5fc0ba3ae09df67b63f5848a8a3'
AND (
token = 'XWugCpH/rwmUlaNgAo0CpuwKSPSACT31jEiHfbrfwRQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)