SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '99c7c855c9c8f51e8119e7c426b24ffcee9323f799ee9ad62b4393ffca08f1c8' 
  AND token = '/WA/cFFugnzC0fZx2EIP5OI3bsM7Nx4A0cIyAri/QjU=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00021

JSON explain

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