UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i8xMDnKXaYkMvGWi4QoLWsZpQ1RDabUvcHXzH0rSZoE='
WHERE
key_id = '67973f8f27f1ea257b31b03e72bf0b489bc37c1f1aacab4848b56c20919659f4'
AND (
token = 'i8xMDnKXaYkMvGWi4QoLWsZpQ1RDabUvcHXzH0rSZoE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)