SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '2fe6adb8479c5d2a95872b6a9f0bb68b19ce2082fe4bba8c464b61d90cf51a3f' 
  AND token = 'zbQcAl8qDjRy+wIFf9y+rsWoPa8VW8bPiy8dhEXWDa4=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00039

JSON explain

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