SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '0c975f57e13cb44bfc05e6fd443c644a58b98bb9260d30b480a1d2e794d1a555' 
  AND token = 'ckQRJ7eT6eMQu5VKrKDbkwW8Bgn18AMl6HaSsqPfvaM=' 
  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"
    }
  }
}