SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '803000f4ca5478b2683ec58bc03331c1620da87be739f0f070c6cb3aefa60e8d' 
  AND token = 'A1bYDwAxG/tmBImRzDrx3Twxb4kePJyp0SMpob4ku3M=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00018

JSON explain

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