UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '6o45XjOY2M89/YVQ+MWKQfdgwTcI97YIi7qZif8Aftk=' 
WHERE 
  key_id = '2801deb359e39a7e72a3720e78f44eadff4bdb97cf592a63f2c304005b08b51f' 
  AND (
    token = '6o45XjOY2M89/YVQ+MWKQfdgwTcI97YIi7qZif8Aftk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033