SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '6bcbf35ca2255609786da7e2999b627deb8bd70594a25df5167a8e9f9c8c197e' 
  AND token = 'C/M4GUpbEp8tw5MZ0YcP0C3L6694RERcisISvKmFpCI=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00051

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "message": "Impossible WHERE noticed after reading const tables"
    }
  }
}