SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '166a551127f106750842e00ca4f78e7b4da5186a1edcc6e9c964e7746d8d94ab' 
  AND token = '+4119r2vSUplOTig8hM/apUYO5l0qPNbkL8eLeUyxI4=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00045

JSON explain

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