SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '8f6f3e051613773ba711c5319de98f8a74754f051f8b37fa8ae8620a48556458' 
  AND token = '+tZyzB2VWCUy1xF9n2aJIGFZmHb/DmJcZWrZfUi1cMQ=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00046

JSON explain

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