UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Gp+riaCFmuB7bThdHpfdeJjp9dJM5VhOXccZ2LJs5y4=' 
WHERE 
  key_id = 'd11f749d3cca7fb8a9fb8f3e2060134f77fce2f2247e9346f8f4db00fc7ddb6f' 
  AND (
    token = 'Gp+riaCFmuB7bThdHpfdeJjp9dJM5VhOXccZ2LJs5y4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035