SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '1ddf6d5ddd92ff0f4adad3b244f2dd7cd958d629dd379b36149715ae4fb67eb1' 
  AND token = 'zLzKXKhMxSKa5y5L5z1EqfK04gD9sIY+94IZ+xYzDoU=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00022

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}