SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '1bfe99438bb4cfb606135740e716a59fc76079e6aafb26bd2b1d6fe46d67413b' 
  AND token = '1Rou0bd70lRvmQGzmP/q+2CX1lT8y//lXjINOBxv414=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00026

JSON explain

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